using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using Microsoft.ApplicationBlocks;
using BusinessRules;
using DataAccess;

namespace BusinessRules
{
    public class FinEpAuditoria
    {
        private const String FAE_ID_PARAM = "@FAE_ID";
        //private const String ZON_ID_PARAM = "@ZON_ID";
        
        //private const String RES_NOMBRE_PARAM = "@RES_NOMBRE";
        
        private string _CadenaConexion;

        public string CadenaConexion
        {
            get { return _CadenaConexion; }
            set { _CadenaConexion = value; }
        }

        public FinEpAuditoria(string strCadenaConecxion)
        {
            CadenaConexion = strCadenaConecxion;
        }



        //public BasResguardosData BuscarTodos()
        //{
        //    BasResguardosData objBasResguardosData = new BasResguardosData();
        //    Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataTable(CadenaConexion, CommandType.StoredProcedure, "PAS_BUSCAR_BAS_RESGUARDO", objBasResguardosData);
        //    return objBasResguardosData;
        //}

        public FinEpAuditoriaData ConsultarFinEPAuditoria(string strFaeId)
        {
            FinEpAuditoriaData objFinEpAuditoriaData = new FinEpAuditoriaData();
            SqlParameter param1 = new SqlParameter(FAE_ID_PARAM, strFaeId);
            SqlParameter[] parameters = { param1 };
            Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataTable(CadenaConexion, CommandType.StoredProcedure, "PAS_CONSULTAR_FIN_EPE_AUDITORIA_FAE_ID", objFinEpAuditoriaData, parameters);
            return objFinEpAuditoriaData;
        }

        
        
    }
}
